<CFQUERY NAME="getorders" DATASOURCE="#dsn#">
select * 
from tblprofiles
order by LastName
</CFQUERY>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 14px;
	color: #FFFFFF;
}
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #1b3b63;
}
.style1 {
	font-size: 18px;
	font-weight: bold;
}
.style2 {
	font-size: 18px;
	font-weight: bold;
	color:#666666;
}
.style5 {
	font-size: 20px;
	font-weight: bold;
}
-->
</style></head>

<body>
      <table width="96%" height="286" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td width="50%" height="35" valign="middle"><span class="style5">CUSTOMER EDIT </span></td>
          <td width="50%" align="right" valign="middle">&nbsp;</td>
        </tr>
        <tr>
          <td colspan="2"><hr size="1" noshade="noshade" /></td>
        </tr>
        <cfif not isdefined("form.amountpaid")></cfif>
        <tr>
          <td height="36" colspan="2" valign="top" class="style1"><cfform name="form1" method="post" action="../../forms/add_cust_order.cfm">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="40%" height="36" bordercolor="#FFFFCC">Any Part of Customer Name</td>
                <td width="60%" height="36" bordercolor="#FFFFCC"><label>
                <cfinput type="text" name="text" class="style2">
                <input name="button" type="submit" class="style2" id="button" value="Search" />
                </label></td>
              </tr>
            </table>
          </cfform></td>
        </tr>
        <tr>
          <td colspan="2" valign="top" class="style1"><label></label>
            <table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#EEEEEE">
              <tr>
                <td width="29%" height="36" background="../../images/fieldbg.png" class="style2">Name</td>
                <td width="27%" height="36" background="../../images/fieldbg.png" class="style2">Address</td>
                <td width="24%" height="36" background="../../images/fieldbg.png" class="style2">City</td>
                <td width="10%" height="36" background="../../images/fieldbg.png" class="style2">State</td>
                <td height="36" colspan="2" background="../../images/fieldbg.png" class="style2">&nbsp;</td>
              </tr>
            <cfoutput query="getorders"> <tr>
                <td>#CompanyName#</td>
                <td>#Address#&nbsp;</td>
                <td>#City#&nbsp;</td>
                <td>#State#&nbsp;</td>
                <td width="5%"><a href="index.cfm?DODAAC=#DODAAC#"><img src="../images/edit.png" alt="EDIT" width="55" height="51" border="0" /></a></td>
                <td width="5%"><img src="../images/reports.png" width="55" height="51" /></td>
              </tr></cfoutput>
            </table></td>
        </tr>
        
        <tr>
          <td height="67" colspan="2" align="center"><label></label></td>
        </tr>
      </table>
  <!---</cfif>--->
    </td>
    </tr>
</table>
</body>
</html>
